TUniSQL Members

TUniSQL class overview.

Properties

Name	Description
ChangeCursor (inherited from TCustomDASQL)	Enables or disables changing screen cursor when executing commands in the NonBlocking mode.
Connection	Used to specify the connection in which the script will be executed.
Debug (inherited from TCustomDASQL)	Used to display the statement that is being executed and the values and types of its parameters.
FinalSQL (inherited from TCustomDASQL)	Used to return a SQL statement with expanded macros.
LastInsertId	Can be used with MySQL, PostgreSQL, and SQL servers to get the value of the ID field after executing INSERT statement.
MacroCount (inherited from TCustomDASQL)	Used to get the number of macros associated with the Macros property.
Macros (inherited from TCustomDASQL)	Makes it possible to change SQL queries easily.
ParamCheck (inherited from TCustomDASQL)	Used to specify whether parameters for the Params property are implicitly generated when the SQL property is being changed.
ParamCount (inherited from TCustomDASQL)	Indicates the number of parameters in the Params property.
Params (inherited from TCustomDASQL)	Used to contain parameters for a SQL statement.
ParamValues (inherited from TCustomDASQL)	Used to get or set the values of individual field parameters that are identified by name.
Prepared (inherited from TCustomDASQL)	Used to indicate whether a query is prepared for execution.
RowsAffected (inherited from TCustomDASQL)	Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.
SpecificOptions	Provides extended settings for each data provider.
SQL (inherited from TCustomDASQL)	Used to provide a SQL statement that a TCustomDASQL component executes when the Execute method is called.
Transaction	Used to specify the TUniTransaction object in the context of which SQL commands will be executed, and queries retrieving data will be opened.

Methods

Name	Description
BreakExec (inherited from TCustomDASQL)	Breaks execution of an SQL satatement on the server.
CreateProcCall	Assigns a command that calls stored procedure specified by Name to the SQL property.
Execute (inherited from TCustomDASQL)	Overloaded. Executes a SQL statement on the server.
Executing (inherited from TCustomDASQL)	Checks whether TCustomDASQL still executes a SQL statement.
FindMacro (inherited from TCustomDASQL)	Finds a macro with the specified name.
FindParam	Searches for a parameter with the specified name.
MacroByName (inherited from TCustomDASQL)	Finds a macro with the specified name.
ParamByName	Searches for a parameter with the specified name.
Prepare (inherited from TCustomDASQL)	Allocates, opens, and parses cursor for a query.
UnPrepare (inherited from TCustomDASQL)	Frees the resources allocated for a previously prepared query on the server and client sides.
WaitExecuting (inherited from TCustomDASQL)	Waits until TCustomDASQL executes a SQL statement.

Events

Name	Description
AfterExecute (inherited from TCustomDASQL)	Occurs after a SQL statement has been executed.

© 1997-2024 Devart. All Rights Reserved.

Request Support

Provide Feedback